create external table jms_dm.dm_door_sign_rate_dt 
(
date_time date COMMENT '日期分区',
end_agent_code string COMMENT '代理区' ,
end_agent_name string COMMENT '代理区' ,
final_sign_network_code string COMMENT '网点' ,
final_sign_network_name string COMMENT '网点' ,
aging_sign bigint COMMENT '时效签收票数' ,
door_sign bigint COMMENT '送货上门票数' ,
xusign bigint COMMENT '虚假签收票数' ,
door_sign_rate decimal(16,4) COMMENT '送货上门率' ,
stage_sign bigint COMMENT '送入驿站票数',
expand1 bigint COMMENT '预留字段1',
expand2 bigint COMMENT '预留字段2',
expand3 bigint COMMENT '预留字段3',
expand4 bigint COMMENT '预留字段4',
expand5 bigint COMMENT '预留字段5'
 )
comment '送货上门率导数'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_door_sign_rate_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
